Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DECIMALCHAR

(Read-only) The DECIMALCHAR option is the value specified for the NLS_NUMERIC_CHARACTERS option.

DECIMALCHAR only affects the way Oracle OLAP formats numbers in output. When you format numbers for input, use a period (`.`) for the decimal marker. To use a different decimal marker, enclose the value in single quotes and use the TO_NUMBER function to convert the value from text to a valid number.

Data type

ID

Syntax

DECIMALCHAR

Examples

Example 10-1 Identifying the Decimal and Thousands Markers

The statements in this example show the DECIMALCHAR and THOUSANDSCHAR values.

- The following statement might produce a comma as output.

      SHOW THOUSANDSCHAR

- The following statement might produce a period as output.

      SHOW DECIMALCHAR

- With these values, the following statement might produce the output that follows it.

      SHOW TOTAL(sales)
      63,181,743.50